package com.lingCheng.avg.mapper;

import com.lingCheng.avg.entity.AgvErrorInfo;
import com.lingCheng.avg.entity.MemItem;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lingCheng.avg.entity.SrmInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 吕继锋
* @description 针对表【mem_item(数据点)】的数据库操作Mapper
* @createDate 2023-12-21 12:50:00
* @Entity com.lingCheng.avg.entity.MemItem
*/
@Mapper
public interface MemItemMapper extends BaseMapper<MemItem> {

    List<MemItem> findErrorInfo();

    MemItem findERRMSG(String code);

    MemItem findERRMSG2(String code);

    SrmInfo getSrmInfo(@Param("deviceId") String deviceId);

    @Select("select * from agv_error where TIMESTAMPDIFF(MINUTE, updateTime, NOW()) <= 1;")
    List<AgvErrorInfo> getAgvErrorInfo ();
}




